Export stock item locations (warehouses)

Find this screen

Open: Stock Control > Utilities > Import and Export > Export Stock Record Locations

How to

Export stock item locations

Use this to export stock item locations to a CSV file.

You can make changes to your items using an external tool (such as Excel), and then import your updated information back into Sage 200.

Open: Stock Control > Utilities > Import and Export > Export Stock Record Locations

1. Choose the stock items to export.

   • All stock items: Export all stock items.

   • Selection: Export a selection of stock items.

     • You can choose to include items from particular warehouses and product groups.

       Note: All warehouses and product groups will be included by default, unless you select a warehouse or product group. For example, if you want to select stock items from warehouse Warehouse 1 but for all product groups, then select Warehouse 1 and don't select any product groups.

2. Select OK and confirm that you want to export.

3. Enter a name for the export file, then select Save.

---

Useful info

About exporting stock item locations

Stock item locations are exported to a CSV Comma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file format.

The stock item locations are exported in the same format that can be used for importing stock item locations, and also for deleting stock item locations.

You can export locations for all stock items, or a selection of stock items by warehouse or product group.

For more information, see:

• Import stock item locations (warehouses).

• Delete stock item locations (warehouses).

Exporting and updating information

Some information can be exported to a CSV file, which can make updating the information easier if you need to make a lot of changes.

The information is exported to a CSV file in the same format used for an import. This means you can export information and make changes to it using an external tool (such as Excel), and then import your updated information back into Sage 200.

For details of which records you can export and update, see What can I import, export and update?

Updating information

• An import file can include information for both new records and existing records that you want to update. You can choose whether or not to update existing records when you import.

• Check the import format spreadsheet (XLS/XSLX file) for details about each import format.

• Not all fields need to be included in the import file. You only need to include the mandatory fields.

  • If you do not want to include a field for a particular record, just leave that field blank.
  • If you do not want to include a field for any of the records in your import file, then you can remove the field altogether (including the heading).